DB2 SQL-Error: -802
SQLState: 22012 if ZERO DIVIDE.
Short Description: EXCEPTION ERROR HAS OCCURRED DURING OPERATION ON DATA POSITION OPEN SQLCODE I OPEN CURSOR P E SQL T I SELECT SELECT SELECT T S SQLCODE P A INTEGER SMALLINT A A A E A O A J JAVA CONVERSION DECIMAL CALL C A BI F I FUNCTION T
An exception error has occurred in the processing of an SQL arithmetic function or arithmetic expression. This error may be indicated by exception-type. Possible values for exception-type are FIXED POINT OVERFLOW, DECIMAL OVERFLOW, ZERO DIVIDE, DIVIDE EXCEPTION, EXPONENT OVERFLOW, or OUT OF RANGE. The exception error occurred in one of the following areas: v In the SELECT list of an SQL SELECT statement. v In the search condition of a SELECT, UPDATE, or DELETE statement. v In the SET clause of the UPDATE statement. v Found during the evaluation of an aggregate function. Data-type may indicate the data types of the items being manipulated. Possible values for data-type are INTEGER, SMALLINT, DECIMAL, and FLOAT. The data type displayed in the message may indicate the data type of the temporary internal copy of the data, which may differ from the actual column or literal data type due to conversions by DB2. Operation-type may indicate the arithmetic operation that was being performed at the time of the error. The possible operation-types are ADDITION, SUBTRACTION, MULTIPLICATION, DIVISION, NEGATION, BUILT-IN FUNCTION, AGGREGATE FUNCTION, and JAVA CONVERSION. Position-number may indicate the position of the expression in a SELECT list if the error was in the SELECT list of an outer SELECT statementNote: Parts of exception-type, data-type, operation-type, and/or position-number may not be returned to the SQL communication area, depending on where the error was detected.System action: The statement cannot be executed. In the case of an INSERT or UPDATE statement, no data is updated or deleted. If the statement was a cursor-controlled FETCH, then the CURSOR will remain open unless the exception occurred while processing an aggregate function (indicated by operation-type of AGGREGATE FUNCTION), in which case the CURSOR will be closed. If the CURSOR is closed, subsequent attempts to use that cursor without